# -*- coding: utf-8 -*-

"""A basic example of using the association object pattern.

The association object pattern is a richer form of a many-to-many
relationship.

The model will be an ecommerce example.  We will have an Order, which
represents a set of Items purchased by a user.  Each Item has a price.
However, the Order must store its own price for each Item, representing
the price paid by the user for that particular order, which is independent
of the price on each Item (since those can change).
"""

#import logging
from datetime import datetime

from sqlalchemy import *

from sqlalchemy.orm import *

from tables import *



"""

def item(name):
    return session.query(Item).filter_by(description=name).one()

"""

# Uncomment these to watch database activity.
#logging.basicConfig(format='%(message)s')
#logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)


class DataBase:

    def __init__(self, echo = False):
        print "create engine"


def test():
    pass
if __name__ == "__main__":
    test()
